Hệ thống quản lý phương tiện trong PHP
1 <?php
2
3 $id= $_GET['id'];
4
5 $conn=mysqli_connect('localhost','root','','vehiclemanagement');
6 $sql="SELECT * FROM bill WHERE id='$id'";
7 $result=mysqli_query($conn,$sql);
8
9 $bill=mysqli_fetch_assoc($result);
10 ?>
11
12 <!DOCTYPE html>
13 <html lang="en">
14 <head>
15 <meta charset="utf-8">
16 <meta http-equiv="X-UA-Compatible" content="IE=edge">
17 <meta name="viewport" content="width=device-width, initial-scale=1">
18 <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
19 <title>Welcome</title>
20
21 <!-- Bootstrap -->
22 <link href="css/bootstrap.min.css" rel="stylesheet">
23
24 <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
25 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
26 <!--[if lt IE 9]>
27 <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
28 <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
29 <![endif]-->
30 </head>
31 <body>
32
33 <br><br><br>
34 <?php include 'navbar_admin.php';?>
35
36 <div class="container">
37 <div class="row">
38 <div class="col-md-2">
39 <a class="btn btn-info" href="indexbill.php">Bill List</a>
40 </div>
41 <div class="col-md-6">
42 <h2>Billing Information</h2>
43 <hr>
44
45 <table class="table" >
46
47 <tr>
48 <th >Service Charge:</th>
49 <td><?php echo $bill['salary']; ?></td>
50 </tr>
51 <tr>
52 <th >Equipment:</th>
53 <td><?php echo $bill['equipment']; ?></td>
54 </tr>
55 <tr>
56 <th >Oil:</th>
57 <td><?php echo $bill['oil']; ?></td>
58 </tr>
59 <tr>
60 <th >Total Cost:</th>
61 <td><?php echo $bill['tcost']; ?></td>
62 </tr>
63 </table>
64
65 </div>
66 </div>
67 </div>
68
69
70 <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
71 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
72 <!-- Include all compiled plugins (below), or include individual files as needed -->
73 <script src="js/bootstrap.min.js"></script>
74 </body>
75 </html>